﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Trends.aspx.cs" Inherits="WebApplicationRating.Views.Trends" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <style type="text/css">
        .style2
        {
            width: 393px;
        }
        .style4
        {
            width: 322px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <asp:TextBox ID="tbMGID" runat="server" Width="2px" Enabled="false" Visible="false" 
        style="margin-left: 30px" Height="16px"></asp:TextBox>
    <asp:Button ID="btnBack" runat="server" style="margin-left: 350px" onclick="btnBack_Click" Text="Back" />&nbsp;&nbsp;
    <br />
    <br />
 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="imageid" DataSourceID="SqlDataSource1">
 <Columns>
 <asp:BoundField DataField="imageid" HeaderText="imageid" InsertVisible="False" ReadOnly="True" SortExpression="imageid" />
 <asp:BoundField DataField="ImageName" HeaderText="ImageName" 
         SortExpression="ImageName" />
     <asp:BoundField DataField="CategoryName" HeaderText="CategoryName" 
         SortExpression="CategoryName" />
 <asp:TemplateField HeaderText="Image">
         <ItemTemplate>
           <asp:Image ID="Image1" runat="server" Width='120'
           ImageUrl='<%# "Handler.ashx?imageid=" + Eval("imageid")%>'/>
         </ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:imageConnectionString %>"    
        
        SelectCommand="SELECT Image.imageid, Image.name AS ImageName, Category.category_name AS CategoryName, Image.image_file FROM Image INNER JOIN ImageCategory ON Image.imageid = ImageCategory.imageid INNER JOIN Category ON ImageCategory.categoryid = Category.categoryid WHERE (Image.imageid = @imageid)"  
        OnSelecting="SqlDataSource_Selecting">
        
       <SelectParameters>
             <asp:ControlParameter ControlID="tbMGID" Name="imageid" PropertyName="Text" />
       </SelectParameters>
 </asp:SqlDataSource>
 <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ** All Stats Are Limited to Category(s) Above ** </p>
<table>
<tr>
<td class="style2">
&nbsp;<asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource3" 
        EmptyDataText="There are no data records to display." 
        style="margin-top: 0px; margin-left: 112px;" Caption="Rated Image Highest">
        <Columns>
            <asp:BoundField DataField="userid" HeaderText="userid" 
                SortExpression="userid" />
            <asp:BoundField DataField="alias" HeaderText="alias" SortExpression="alias" />
            <asp:BoundField DataField="imageid" HeaderText="imageid" 
                SortExpression="imageid" />
            <asp:BoundField DataField="rating" HeaderText="rating" 
                SortExpression="rating" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
        ConnectionString="<%$ ConnectionStrings:imageConnectionString2 %>" 
        DeleteCommand="DELETE FROM [UserImageRating] WHERE [user_image_rating_id] = @user_image_rating_id" 
        InsertCommand="INSERT INTO [UserImageRating] ([userid], [imageid], [rating], [rating_date]) VALUES (@userid, @imageid, @rating, @rating_date)" 
        ProviderName="<%$ ConnectionStrings:imageConnectionString2.ProviderName %>" 
        SelectCommand="SELECT UserImageRating.userid, RegisteredUser.alias, UserImageRating.imageid, UserImageRating.rating FROM UserImageRating INNER JOIN RegisteredUser ON UserImageRating.userid = RegisteredUser.userid AND UserImageRating.imageid = @imageid AND UserImageRating.rating IN (SELECT MAX(rating) AS Expr1 FROM UserImageRating WHERE (imageid = @imageid) HAVING (MAX(rating) &gt; (SELECT MIN(rating) AS Expr1 FROM UserImageRating WHERE (imageid = @imageid))))" 
        OnSelecting="SqlDataSource_Selecting" 
        
        UpdateCommand="UPDATE [UserImageRating] SET [userid] = @userid, [imageid] = @imageid, [rating] = @rating, [rating_date] = @rating_date WHERE [user_image_rating_id] = @user_image_rating_id">
        <SelectParameters>
             <asp:ControlParameter ControlID="tbMGID" Name="imageid" PropertyName="Text" />
         </SelectParameters>
        <DeleteParameters>
            <asp:Parameter Name="user_image_rating_id" Type="Int32" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="userid" Type="Int32" />
            <asp:Parameter Name="imageid" Type="Int32" />
            <asp:Parameter Name="rating" Type="Decimal" />
            <asp:Parameter Name="rating_date" Type="DateTime" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="userid" Type="Int32" />
            <asp:Parameter Name="imageid" Type="Int32" />
            <asp:Parameter Name="rating" Type="Decimal" />
            <asp:Parameter Name="rating_date" Type="DateTime" />
            <asp:Parameter Name="user_image_rating_id" Type="Int32" />
        </UpdateParameters>
    </asp:SqlDataSource>
    </td>
    <td class="style4">
    <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" 
        EmptyDataText="There are no data records to display." 
        style="margin-top: 19px; margin-left: 47px;" Caption="Rated Image Lowest" >
        <Columns>
            <asp:BoundField DataField="userid" HeaderText="userid" 
                SortExpression="userid" />
            <asp:BoundField DataField="alias" HeaderText="alias" SortExpression="alias" />
            <asp:BoundField DataField="imageid" HeaderText="imageid" 
                SortExpression="imageid" />
            <asp:BoundField DataField="rating" HeaderText="rating" 
                SortExpression="rating" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConnectionString="<%$ ConnectionStrings:imageConnectionString2 %>" 
        DeleteCommand="DELETE FROM [UserImageRating] WHERE [user_image_rating_id] = @user_image_rating_id" 
        InsertCommand="INSERT INTO [UserImageRating] ([userid], [imageid], [rating], [rating_date]) VALUES (@userid, @imageid, @rating, @rating_date)" 
        ProviderName="<%$ ConnectionStrings:imageConnectionString2.ProviderName %>" 
        SelectCommand="SELECT UserImageRating.userid, RegisteredUser.alias, UserImageRating.imageid, UserImageRating.rating FROM UserImageRating INNER JOIN RegisteredUser ON UserImageRating.userid = RegisteredUser.userid AND UserImageRating.imageid = @imageid AND UserImageRating.rating IN (SELECT MIN(rating) AS Expr1 FROM UserImageRating WHERE (imageid = @imageid) HAVING (MIN(rating) &lt; (SELECT MAX(rating) AS Expr1 FROM UserImageRating WHERE (imageid = @imageid))))" 
        OnSelecting="SqlDataSource_Selecting"  
        
        UpdateCommand="UPDATE [UserImageRating] SET [userid] = @userid, [imageid] = @imageid, [rating] = @rating, [rating_date] = @rating_date WHERE [user_image_rating_id] = @user_image_rating_id">
        <SelectParameters>
             <asp:ControlParameter ControlID="tbMGID" Name="imageid" PropertyName="Text" />
         </SelectParameters>
        <DeleteParameters>
            <asp:Parameter Name="user_image_rating_id" Type="Int32" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="userid" Type="Int32" />
            <asp:Parameter Name="imageid" Type="Int32" />
            <asp:Parameter Name="rating" Type="Decimal" />
            <asp:Parameter Name="rating_date" Type="DateTime" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="userid" Type="Int32" />
            <asp:Parameter Name="imageid" Type="Int32" />
            <asp:Parameter Name="rating" Type="Decimal" />
            <asp:Parameter Name="rating_date" Type="DateTime" />
            <asp:Parameter Name="user_image_rating_id" Type="Int32" />
        </UpdateParameters>
    </asp:SqlDataSource>
    </td>
    </tr>
    <tr>
    <td class="style2">
      &nbsp;&nbsp;&nbsp;&nbsp;
      <asp:GridView ID="GridView6" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource6" 
        EmptyDataText="There are no data records to display." 
        style="margin-top: 0px; margin-left: 144px;" 
        Caption="High Group Other Image" >
        <Columns>
            <asp:BoundField DataField="imageid" HeaderText="imageid" 
                SortExpression="imageid" />
            <asp:BoundField DataField="HighGrpAvgRating" HeaderText="HighGrpAvgRating" 
                ReadOnly="True" SortExpression="HighGrpAvgRating" 
                DataFormatString="{0:n2}" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource6" runat="server" 
        ConnectionString="<%$ ConnectionStrings:imageConnectionString2 %>" 
        DeleteCommand="DELETE FROM [UserImageRating] WHERE [user_image_rating_id] = @user_image_rating_id" 
        InsertCommand="INSERT INTO [UserImageRating] ([userid], [imageid], [rating], [rating_date]) VALUES (@userid, @imageid, @rating, @rating_date)" 
        ProviderName="<%$ ConnectionStrings:imageConnectionString2.ProviderName %>" 
        SelectCommand="SELECT UserImageRating.imageid, AVG(UserImageRating.rating) AS HighGrpAvgRating FROM UserImageRating INNER JOIN ImageCategory ON UserImageRating.imageid = ImageCategory.imageid AND ImageCategory.categoryid IN (SELECT categoryid FROM ImageCategory WHERE (imageid = @imageid)) WHERE (UserImageRating.imageid &lt;&gt; @imageid) AND (UserImageRating.imageid IN (SELECT imageid FROM UserImageRating AS UserImageRating_3 WHERE (imageid &lt;&gt; @imageid) AND (userid IN (SELECT userid AS Expr7 FROM UserImageRating AS UserImageRating_7 WHERE (imageid = @imageid) GROUP BY userid HAVING (MIN(rating) &lt; (SELECT MAX(rating) AS Expr7 FROM UserImageRating AS UserImageRating_7 WHERE (imageid = @imageid))))))) AND (UserImageRating.userid IN (SELECT userid AS Expr1 FROM UserImageRating AS UserImageRating_2 WHERE (imageid = @imageid) GROUP BY userid HAVING (MAX(rating) &gt; (SELECT MIN(rating) AS Expr1 FROM UserImageRating AS UserImageRating_1 WHERE (imageid = @imageid))))) GROUP BY UserImageRating.imageid ORDER BY UserImageRating.imageid" 
        OnSelecting="SqlDataSource_Selecting" 
        
        
        
        
            UpdateCommand="UPDATE [UserImageRating] SET [userid] = @userid, [imageid] = @imageid, [rating] = @rating, [rating_date] = @rating_date WHERE [user_image_rating_id] = @user_image_rating_id">
        <SelectParameters>
             <asp:ControlParameter ControlID="tbMGID" Name="imageid" PropertyName="Text" />
         </SelectParameters>
        <DeleteParameters>
            <asp:Parameter Name="user_image_rating_id" Type="Int32" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="userid" Type="Int32" />
            <asp:Parameter Name="imageid" Type="Int32" />
            <asp:Parameter Name="rating" Type="Decimal" />
            <asp:Parameter Name="rating_date" Type="DateTime" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="userid" Type="Int32" />
            <asp:Parameter Name="imageid" Type="Int32" />
            <asp:Parameter Name="rating" Type="Decimal" />
            <asp:Parameter Name="rating_date" Type="DateTime" />
            <asp:Parameter Name="user_image_rating_id" Type="Int32" />
        </UpdateParameters>
    </asp:SqlDataSource>
    </td>
    <td class="style4">
    &nbsp;
    <asp:GridView ID="GridView7" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource7" 
        EmptyDataText="There are no data records to display." 
         style="margin-top: 0px; margin-left: 47px;" 
        Caption="Low Group Other Image" Width="211px" >
        <Columns>
            <asp:BoundField DataField="imageid" HeaderText="imageid" 
                SortExpression="imageid" />
            <asp:BoundField DataField="LowGrpAvgRating" HeaderText="LowGrpAvgRating" 
                ReadOnly="True" SortExpression="LowGrpAvgRating" 
                DataFormatString="{0:n2}" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource7" runat="server" 
        ConnectionString="<%$ ConnectionStrings:imageConnectionString2 %>" 
        DeleteCommand="DELETE FROM [UserImageRating] WHERE [user_image_rating_id] = @user_image_rating_id" 
        InsertCommand="INSERT INTO [UserImageRating] ([userid], [imageid], [rating], [rating_date]) VALUES (@userid, @imageid, @rating, @rating_date)" 
        ProviderName="<%$ ConnectionStrings:imageConnectionString2.ProviderName %>" 
        SelectCommand="SELECT UserImageRating.imageid, AVG(UserImageRating.rating) AS LowGrpAvgRating FROM UserImageRating INNER JOIN ImageCategory ON UserImageRating.imageid = ImageCategory.imageid AND ImageCategory.categoryid IN (SELECT categoryid FROM ImageCategory WHERE (imageid = @imageid)) WHERE (UserImageRating.imageid &lt;&gt; @imageid) AND (UserImageRating.imageid IN (SELECT imageid FROM UserImageRating AS UserImageRating_3 WHERE (imageid &lt;&gt; @imageid) AND (userid IN (SELECT userid AS Expr7 FROM UserImageRating AS UserImageRating_7 WHERE (imageid = @imageid) GROUP BY userid HAVING (MAX(rating) &gt; (SELECT MIN(rating) AS Expr7 FROM UserImageRating AS UserImageRating_7 WHERE (imageid = @imageid))))))) AND (UserImageRating.userid IN (SELECT userid AS Expr1 FROM UserImageRating AS UserImageRating_2 WHERE (imageid = @imageid) GROUP BY userid HAVING (MIN(rating) &lt; (SELECT MAX(rating) AS Expr1 FROM UserImageRating AS UserImageRating_1 WHERE (imageid = @imageid))))) GROUP BY UserImageRating.imageid ORDER BY UserImageRating.imageid" 
        OnSelecting="SqlDataSource_Selecting" 
        
        
        
            UpdateCommand="UPDATE [UserImageRating] SET [userid] = @userid, [imageid] = @imageid, [rating] = @rating, [rating_date] = @rating_date WHERE [user_image_rating_id] = @user_image_rating_id">
        <SelectParameters>
             <asp:ControlParameter ControlID="tbMGID" Name="imageid" PropertyName="Text" />
         </SelectParameters>
        <DeleteParameters>
            <asp:Parameter Name="user_image_rating_id" Type="Int32" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="userid" Type="Int32" />
            <asp:Parameter Name="imageid" Type="Int32" />
            <asp:Parameter Name="rating" Type="Decimal" />
            <asp:Parameter Name="rating_date" Type="DateTime" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="userid" Type="Int32" />
            <asp:Parameter Name="imageid" Type="Int32" />
            <asp:Parameter Name="rating" Type="Decimal" />
            <asp:Parameter Name="rating_date" Type="DateTime" />
            <asp:Parameter Name="user_image_rating_id" Type="Int32" />
        </UpdateParameters>
    </asp:SqlDataSource>
    </td>
    </tr>
    <tr>
    <td class="style2">
    &nbsp;
    <asp:GridView ID="GridView8" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource8" 
        EmptyDataText="There are no data records to display." 
         style="margin-top: 0px; margin-left: 171px;" 
        Caption="High Group Other AvgRating" Width="63px" >
        <Columns>
            <asp:BoundField DataField="Mean" HeaderText="Mean" ReadOnly="True" 
                SortExpression="Mean" DataFormatString="{0:n2}" />
            <asp:BoundField DataField="StdDEV" DataFormatString="{0:n2}" 
                HeaderText="StdDEV" ReadOnly="True" SortExpression="StdDEV" />
            <asp:BoundField DataField="Variance" DataFormatString="{0:n2}" 
                HeaderText="Variance" ReadOnly="True" SortExpression="Variance" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource8" runat="server" 
        ConnectionString="<%$ ConnectionStrings:imageConnectionString2 %>" 
        DeleteCommand="DELETE FROM [UserImageRating] WHERE [user_image_rating_id] = @user_image_rating_id" 
        InsertCommand="INSERT INTO [UserImageRating] ([userid], [imageid], [rating], [rating_date]) VALUES (@userid, @imageid, @rating, @rating_date)" 
        ProviderName="<%$ ConnectionStrings:imageConnectionString2.ProviderName %>" 
        SelectCommand="SELECT AVG(HighGrpAvgRating) AS Mean, STDEV(HighGrpAvgRating) AS StdDEV, VARP(HighGrpAvgRating) AS Variance FROM (SELECT TOP (100) PERCENT UserImageRating.imageid, AVG(UserImageRating.rating) AS HighGrpAvgRating FROM UserImageRating INNER JOIN ImageCategory ON UserImageRating.imageid = ImageCategory.imageid AND ImageCategory.categoryid IN (SELECT categoryid FROM ImageCategory WHERE (imageid = @imageid)) WHERE (UserImageRating.imageid &lt;&gt; @imageid) AND (UserImageRating.imageid IN (SELECT imageid FROM UserImageRating AS UserImageRating_3 WHERE (imageid &lt;&gt; @imageid) AND (userid IN (SELECT userid AS Expr7 FROM UserImageRating AS UserImageRating_7 WHERE (imageid = @imageid) GROUP BY userid HAVING (MIN(rating) &lt; (SELECT MAX(rating) AS Expr7 FROM UserImageRating AS UserImageRating_7 WHERE (imageid = @imageid))))))) AND (UserImageRating.userid IN (SELECT userid AS Expr1 FROM UserImageRating AS UserImageRating_2 WHERE (imageid = @imageid) GROUP BY userid HAVING (MAX(rating) &gt; (SELECT MIN(rating) AS Expr1 FROM UserImageRating AS UserImageRating_1 WHERE (imageid = @imageid))))) GROUP BY UserImageRating.imageid ORDER BY UserImageRating.imageid) AS derivedtbl_1" 
        OnSelecting="SqlDataSource_Selecting" 
        

        
            
            
            UpdateCommand="UPDATE [UserImageRating] SET [userid] = @userid, [imageid] = @imageid, [rating] = @rating, [rating_date] = @rating_date WHERE [user_image_rating_id] = @user_image_rating_id">
        <SelectParameters>
             <asp:ControlParameter ControlID="tbMGID" Name="imageid" PropertyName="Text" />
         </SelectParameters>
        <DeleteParameters>
            <asp:Parameter Name="user_image_rating_id" Type="Int32" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="userid" Type="Int32" />
            <asp:Parameter Name="imageid" Type="Int32" />
            <asp:Parameter Name="rating" Type="Decimal" />
            <asp:Parameter Name="rating_date" Type="DateTime" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="userid" Type="Int32" />
            <asp:Parameter Name="imageid" Type="Int32" />
            <asp:Parameter Name="rating" Type="Decimal" />
            <asp:Parameter Name="rating_date" Type="DateTime" />
            <asp:Parameter Name="user_image_rating_id" Type="Int32" />
        </UpdateParameters>
    </asp:SqlDataSource>
</td>
<td class="style4">
    &nbsp;
    <asp:GridView ID="GridView9" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource9" 
        EmptyDataText="There are no data records to display." 
         style="margin-top: 0px; margin-left: 47px;" 
        Caption="Low Group Other AvgRating" Width="57px" >
        <Columns>
            <asp:BoundField DataField="Mean" HeaderText="Mean" ReadOnly="True" 
                SortExpression="Mean" DataFormatString="{0:n2}" />
            <asp:BoundField DataField="StdDEV" HeaderText="StdDEV" ReadOnly="True" 
                SortExpression="StdDEV" DataFormatString="{0:n2}" />
            <asp:BoundField DataField="Variance" DataFormatString="{0:n2}" 
                HeaderText="Variance" ReadOnly="True" SortExpression="Variance" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource9" runat="server" 
        ConnectionString="<%$ ConnectionStrings:imageConnectionString2 %>" 
        DeleteCommand="DELETE FROM [UserImageRating] WHERE [user_image_rating_id] = @user_image_rating_id" 
        InsertCommand="INSERT INTO [UserImageRating] ([userid], [imageid], [rating], [rating_date]) VALUES (@userid, @imageid, @rating, @rating_date)" 
        ProviderName="<%$ ConnectionStrings:imageConnectionString2.ProviderName %>" 
        SelectCommand="SELECT AVG(LowGrpAvgRating) AS Mean, STDEV(LowGrpAvgRating) AS StdDEV, VARP(LowGrpAvgRating) as Variance FROM (SELECT TOP (100) PERCENT UserImageRating.imageid, AVG(UserImageRating.rating) AS LowGrpAvgRating FROM UserImageRating INNER JOIN ImageCategory ON UserImageRating.imageid = ImageCategory.imageid AND ImageCategory.categoryid IN (SELECT categoryid FROM ImageCategory WHERE (imageid = @imageid)) WHERE (UserImageRating.imageid &lt;&gt; @imageid) AND (UserImageRating.imageid IN (SELECT imageid FROM UserImageRating AS UserImageRating_3 WHERE (imageid &lt;&gt; @imageid) AND (userid IN (SELECT userid AS Expr7 FROM UserImageRating AS UserImageRating_7 WHERE (imageid = @imageid) GROUP BY userid HAVING (MAX(rating) &gt; (SELECT MIN(rating) AS Expr7 FROM UserImageRating AS UserImageRating_7 WHERE (imageid = @imageid))))))) AND (UserImageRating.userid IN (SELECT userid AS Expr1 FROM UserImageRating AS UserImageRating_2 WHERE (imageid = @imageid) GROUP BY userid HAVING (MIN(rating) &lt; (SELECT MAX(rating) AS Expr1 FROM UserImageRating AS UserImageRating_1 WHERE (imageid = @imageid))))) GROUP BY UserImageRating.imageid ORDER BY UserImageRating.imageid) AS derivedtbl_1" 
        OnSelecting="SqlDataSource_Selecting" 
        
        
        
        
        
        
        
        
        UpdateCommand="UPDATE [UserImageRating] SET [userid] = @userid, [imageid] = @imageid, [rating] = @rating, [rating_date] = @rating_date WHERE [user_image_rating_id] = @user_image_rating_id">
        <SelectParameters>
             <asp:ControlParameter ControlID="tbMGID" Name="imageid" PropertyName="Text" />
         </SelectParameters>
        <DeleteParameters>
            <asp:Parameter Name="user_image_rating_id" Type="Int32" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="userid" Type="Int32" />
            <asp:Parameter Name="imageid" Type="Int32" />
            <asp:Parameter Name="rating" Type="Decimal" />
            <asp:Parameter Name="rating_date" Type="DateTime" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="userid" Type="Int32" />
            <asp:Parameter Name="imageid" Type="Int32" />
            <asp:Parameter Name="rating" Type="Decimal" />
            <asp:Parameter Name="rating_date" Type="DateTime" />
            <asp:Parameter Name="user_image_rating_id" Type="Int32" />
        </UpdateParameters>
    </asp:SqlDataSource>
</td>
</tr>
</table>
<br />
    </asp:Content>
